WIP/AR Aging

The WIP/AR Aging report shows accumulated WIP and AR in up to seven user-defined aging intervals. This report can be used to determine how much unbilled WIP and AR have accumulated for each client.

Two versions of the report are available.

  • The standard version allows for extensive customization, filtering, and grouping, but can take a while to generate. You can also add a cover page to this version of the report.
  • The optimized version generates quickly, but offers fewer customization options. Basic report options are preset based on common use of the report and cannot be changed. There are also fewer grouping and filtering options than in the standard report. You can identify this version by the word Optimized in the Type column.

The sections below describe the options available in this report.

Permissions Required for this Report

In the staff profile, staff must be assigned to a security group that is granted View functional rights for the following:

  • Security group profile > Functional rights > Reports > Shared Library > Shared Views
  • Security group profile > Functional rights > Reports > Firm Library > Custom
  • Security group profile > Functional rights > Reports > Firm Library > Standard > Firm
  • Security group profile > Functional rights > Reports > Firm Library > Standard > Practice
  • Security group profile > Functional rights > Reports > Firm Library > <report name>
  • Security group profile > Functional rights > Administration Manager > Client Manager > Approved Clients

Comparable Reports in CCH ProSystem fx Practice Management that are Comparable

In Practice Management, the comparable report is WIP/AR Aging.

Report Specifications

The following report options and filters are available to determine the report contents.

Options and Settings    
Option Setting Description
Note: This section does not display in the optimized report. Instead, certain options are applied by default, as indicated in the descriptions below.

Include Clients with Transactions and AR Balance of $0.00

Yes/ No

Includes or excludes clients with transactions in the date range of the report and those transactions equal $0.00.

For the optimized report, this option is set to No.

Calculate Aging for Undistributed

Payments Using…

List

Determines the date to use for aging undistributed transactions. The options are Undistributed transaction date or Oldest unpaid invoice date.

For the optimized report, this option is set to Undistributed transaction date.

Show Client AR Limit

Yes/No

Includes or excludes the client AR limit.

For the optimized report, this option is set to No.

Show Client Last Payment Date and

Amount

Yes/No

Includes or excludes the last received payment date and amount.

For the optimized report, this option is set to Yes.

Include Clients with Minimum AR

Balance Of…

Numerical

Shows the clients with the specified minimum AR balance on the report.

For the optimized report, this option is not applicable.

Start Aging Period for Minimum AR

Balance At…

Numerical

Determines the aging period to use as the first aging period for the AR balance on the report.

For the optimized report, this option is set to 1.

Include Clients with a Minimum WIP

Balance Of…

Numerical

Shows the clients with the specified minimum WIP balance on the report.

For the optimized report, this option is not applicable.

Start Aging Period for Minimum WIP

Balance At…

Numerical

Determines the aging period to use as the first aging period for the WIP balance on the report.

For the optimized report, this option is set to 1.

Set Number of Days for Aging Period 1

Numerical

Determines the length of each aging period. Enter ‘0’ for periods you wish to hide on the report.

For the optimized report, this option is set to 30.

Set Number of Days for Aging Period 2

Numerical

Determines the length of each aging period. Enter ‘0’ for periods you wish to hide on the report.

For the optimized report, this option is set to 30.

Set Number of Days for Aging Period 3

Numerical

Determines the length of each aging period. Enter ‘0’ for periods you wish to hide on the report.

For the optimized report, this option is set to 30.

Set Number of Days for Aging Period 4

Numerical

Determines the length of each aging period. Enter ‘0’ for periods you wish to hide on the report.

For the optimized report, this option is set to 30.

Set Number of Days for Aging Period 5

Numerical

Determines the length of each aging period. Enter ‘0’ for periods you wish to hide on the report.

For the optimized report, this option is set to 0.

Set Number of Days for Aging Period 6

Numerical

Determines the length of each aging period. Enter ‘0’ for periods you wish to hide on the report.

For the optimized report, this option is set to 0.

Set Number of Days for Aging Period 7

Numerical

Determines the length of each aging period. Enter ‘0’ for periods you wish to hide on the report.

For the optimized report, this option is set to 0.

Select to Age Transaction Using…

List

Determines whether to age the transactions based on the Transaction date or the Accounting period date.

For the optimized report, this option is set to Transaction date.

Cutoff WIP Date (exclude transactions

past this date)

Date

Determines the cutoff date for WIP. This excludes transactions that are after the date entered.

For the optimized report, this option is set to Today.

Cutoff AR Date (exclude transactions

past this date)

Date

Determines the cutoff date for AR. This excludes transactions that are after the date entered.

For the optimized report, this option is set to Today.

Hide AR

Yes/No

Includes or excludes detailed AR transactions.

For the optimized report, this option is set to No.

Include Deleted Clients

Yes/No

Includes or excludes deleted client information.

For the optimized report, this option is set to No.

Default filters
There are no default filters for this report.
Optional Filters    
Available Fields
Note: The options that are available in the optimized report are indicated with an asterisk (*) below.

AR Limit

Client ID.Sub ID*

Financial Reporting Client Group

Business Code

Client Name*

Line of Business

Client

Client Office*

Manager

Client – Principal

Client Primary Service Type

Primary Partner

Client Bill Manager*

Client Region

Return Group

Client Business Unit

Client Sub ID Sort Name

Client ID*

Client Type

 

Note: The Manager and Primary Partner field names are the default values defined for client responsible staff. The first ten client responsible staff List values that are defined by your firm are available field options.

Grouping    
Available Fields
Note: The options that are available in optimized reports are indicated with an asterisk (*) in the tables below.

Business Code

Client Name

Line of Business

Client*

Client Office*

Manager

Client – Principal

Client Primary Service Type

Primary Partner

Client Bill Manager*

Client Region

Return Group

Client Business Unit

Client Sub ID

Sort Name*

Client ID*

Client Type

Tax Type

Client ID-Sub ID*

Financial Reporting Client Group*

 

Note: The Manager and Primary Partner field names are the default values defined for client responsible staff. The first ten client responsible staff List values that are defined by your firm are available field options.

Sorting
Note: This section is hidden for the optimized report. However, by default, the report has a static sort by client.

Client

Report Fields

The following fields are available for this report. The fields that display and the position of fields are based on the report's settings, grouping, sorting, and filters.

Report Fields  
Field Description

Client

The client name and ID in Last Name, First Name (Sub-ID) format.

Last Payment

The client’s last payment date and amount.

A/R Limit

The client's AR limit set in the client profile.

Total

The total amount for WIP and AR.

Current

The amount for the current aging for WIP/AR, defined in Options and Settings.

2nd Aging Interval

The amount for the second aging for WIP/AR, defined in Options and Settings.

3rd Aging Interval

The amount for the third aging for WIP/AR, defined in Options and Settings.

4th Aging Interval

The amount for the fourth aging for WIP/AR, defined in Options and Settings.

5th Aging Interval

The amount for the fifth aging for WIP/AR, defined in Options and Settings.

6th Aging Interval

The amount for the sixth aging for WIP/AR, defined in Options and Settings.

7th Aging Interval

The amount for the seventh aging for WIP/AR, defined in Options and Settings.

WIP/AR Aging Sample Report

Optimized WIP/AR Aging Sample Report